Micronet Database Field Name

System, Menu Options and Field Name

dih_date

MDS> SALES | INVOICE CREATION | EDIT | HEADER | Invoice Date

dih_dbtno

MDS> SALES | INVOICE CREATION | Debtors Number

dih_ordno

MDS> SALES | INVOICE CREATION | EDIT | HEADER | Order Number

doh_dbtno

MDS> SALES | BACKORDER CREATION | Debtors Number

doh_ordno

MDS> SALES | BACKORDER CREATION | EDIT | HEADER | Order Number

dol_itmno

MDS> SALES | INVOICE CREATION <select debtor> < Add button> Item Number

dol_supno

MDS> SALES | INVOICE CREATION <select debtor> < Add button> Supplier

dol_wareno

MDS> SALES | BACKORDER CREATION | EDIT | HEADER | Warehouse

itm_cat

MDS> FILE | INVENTORY | Category

itm_class

MDS> FILE | INVENTORY | Class

itm_no

MDS> FILE | INVENTORY | Item Number

itm_presup

MDS> FILE | INVENTORY | Supplier Preferred

job_cusno

MJC> | TRANSACTIONS | JOB TRANSACTIONS | Debtor Number

job_ordno

MJC> TRANSACTIONS | JOB TRANSACTIONS | Order Number

jt_itmno

MJC> TRANSACTIONS | JOB TRANSACTIONS <select debtor> < Add button> Item number

jt_jobno

MJC> TRANSACTIONS | JOB TRANSACTIONS <select debtor> Job Number

jt_stage

MJC> TRANSACTIONS | JOB TRANSACTIONS <select debtor>< Add button> Stage

jt_supplier

MJC> TRANSACTIONS | JOB TRANSACTIONS <select debtor> < Add button> Supplier

jt_wareno

MJC> TRANSACTIONS | JOB TRANSACTIONSS <select debtor> < Add button> Warehouse

posh_cusno

EnPOS> POINT OF SALE | DOCKET CREATION | Debtors Number

posh_date

EnPOS> POINT OF SALE | DOCKET CREATION | Date

posh_ordno

EnPOS> POINT OF SALE | DOCKET CREATION | Order Number

posl_itemno

EnPOS> POINT OF SALE | DOCKET CREATION < Add button> Item Number

posl_supplier

EnPOS> POINT OF SALE | DOCKET CREATION < Add button> Supplier

posl_wareno

EnPOS> POINT OF SALE | DOCKET CREATION < Add button> Warehouse

sup_class

MDS> FILE | SUPPLIER | Class

witm_ordclass

MDS> FILE | INVENTORY | PURCHASING <select warehouse> < Add button> Order Class